Dataset statistics
| Number of variables | 33 |
|---|---|
| Number of observations | 59695 |
| Missing cells | 236 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 15.0 MiB |
| Average record size in memory | 264.0 B |
Variable types
| Numeric | 13 |
|---|---|
| Categorical | 20 |
Country has a high cardinality: 155 distinct values | High cardinality |
Agent has a high cardinality: 296 distinct values | High cardinality |
Company has a high cardinality: 287 distinct values | High cardinality |
ReservationStatusDate has a high cardinality: 902 distinct values | High cardinality |
IsCanceled is highly correlated with ReservationStatus | High correlation |
ReservationStatus is highly correlated with IsCanceled | High correlation |
Adults is highly skewed (γ1 = 20.93767433) | Skewed |
PreviousCancellations is highly skewed (γ1 = 23.97962684) | Skewed |
PreviousBookingsNotCanceled is highly skewed (γ1 = 23.41816044) | Skewed |
df_index has unique values | Unique |
LeadTime has 3194 (5.4%) zeros | Zeros |
StaysInWeekendNights has 25912 (43.4%) zeros | Zeros |
StaysInWeekNights has 3814 (6.4%) zeros | Zeros |
PreviousCancellations has 56480 (94.6%) zeros | Zeros |
PreviousBookingsNotCanceled has 57855 (96.9%) zeros | Zeros |
BookingChanges has 50647 (84.8%) zeros | Zeros |
DaysInWaitingList has 57831 (96.9%) zeros | Zeros |
ADR has 967 (1.6%) zeros | Zeros |
TotalOfSpecialRequests has 35108 (58.8%) zeros | Zeros |
Reproduction
| Analysis started | 2021-01-30 01:23:57.063961 |
|---|---|
| Analysis finished | 2021-01-30 01:24:50.555673 |
| Duration | 53.49 seconds |
| Software version | pandas-profiling v2.10.0 |
| Download configuration | config.yaml |
| Distinct | 59695 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59674.85957 |
|---|---|
| Minimum | 2 |
| Maximum | 119387 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 466.5 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 5987.7 |
| Q1 | 29892.5 |
| median | 59526 |
| Q3 | 89425 |
| 95-th percentile | 113205.3 |
| Maximum | 119387 |
| Range | 119385 |
| Interquartile range (IQR) | 59532.5 |
Descriptive statistics
| Standard deviation | 34386.1497 |
|---|---|
| Coefficient of variation (CV) | 0.5762250627 |
| Kurtosis | -1.198923187 |
| Mean | 59674.85957 |
| Median Absolute Deviation (MAD) | 29772 |
| Skewness | 0.00104454835 |
| Sum | 3562290742 |
| Variance | 1182407291 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 12282 | 1 | < 0.1% |
| 60168 | 1 | < 0.1% |
| 19228 | 1 | < 0.1% |
| 25369 | 1 | < 0.1% |
| 27416 | 1 | < 0.1% |
| 6934 | 1 | < 0.1% |
| 2836 | 1 | < 0.1% |
| 13075 | 1 | < 0.1% |
| 15122 | 1 | < 0.1% |
| 11024 | 1 | < 0.1% |
| Other values (59685) | 59685 |
| Value | Count | Frequency (%) |
| 2 | 1 | |
| 3 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 |
| Value | Count | Frequency (%) |
| 119387 | 1 | |
| 119386 | 1 | |
| 119383 | 1 | |
| 119382 | 1 | |
| 119381 | 1 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 59695 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
| Value | Count | Frequency (%) |
| 0 | 37738 | |
| 1 | 21957 |
| Value | Count | Frequency (%) |
| 0 | 37738 | |
| 1 | 21957 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 37738 | |
| 1 | 21957 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 59695 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 37738 | |
| 1 | 21957 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 59695 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 37738 | |
| 1 | 21957 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 59695 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 37738 | |
| 1 | 21957 |
| Distinct | 472 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 103.5098249 |
|---|---|
| Minimum | 0 |
| Maximum | 629 |
| Zeros | 3194 |
| Zeros (%) | 5.4% |
| Memory size | 466.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 18 |
| median | 69 |
| Q3 | 159 |
| 95-th percentile | 319 |
| Maximum | 629 |
| Range | 629 |
| Interquartile range (IQR) | 141 |
Descriptive statistics
| Standard deviation | 106.7560362 |
|---|---|
| Coefficient of variation (CV) | 1.031361383 |
| Kurtosis | 1.727359234 |
| Mean | 103.5098249 |
| Median Absolute Deviation (MAD) | 60 |
| Skewness | 1.357370779 |
| Sum | 6179019 |
| Variance | 11396.85127 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3194 | 5.4% |
| 1 | 1766 | 3.0% |
| 2 | 1024 | 1.7% |
| 3 | 922 | 1.5% |
| 4 | 838 | 1.4% |
| 5 | 776 | 1.3% |
| 6 | 728 | 1.2% |
| 7 | 643 | 1.1% |
| 8 | 583 | 1.0% |
| 12 | 558 | 0.9% |
| Other values (462) | 48663 |
| Value | Count | Frequency (%) |
| 0 | 3194 | |
| 1 | 1766 | |
| 2 | 1024 | 1.7% |
| 3 | 922 | 1.5% |
| 4 | 838 | 1.4% |
| Value | Count | Frequency (%) |
| 629 | 10 | |
| 626 | 14 | |
| 622 | 9 | |
| 615 | 9 | |
| 608 | 6 |
ArrivalDateYear
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| 2016 | |
|---|---|
| 2017 | |
| 2015 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 238780 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2015 |
|---|---|
| 2nd row | 2017 |
| 3rd row | 2016 |
| 4th row | 2016 |
| 5th row | 2016 |
| Value | Count | Frequency (%) |
| 2016 | 28375 | |
| 2017 | 20274 | |
| 2015 | 11046 | 18.5% |
| Value | Count | Frequency (%) |
| 2016 | 28375 | |
| 2017 | 20274 | |
| 2015 | 11046 | 18.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 59695 | |
| 0 | 59695 | |
| 1 | 59695 | |
| 6 | 28375 | |
| 7 | 20274 | 8.5% |
| 5 | 11046 | 4.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 238780 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 2 | 59695 | |
| 0 | 59695 | |
| 1 | 59695 | |
| 6 | 28375 | |
| 7 | 20274 | 8.5% |
| 5 | 11046 | 4.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 238780 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 2 | 59695 | |
| 0 | 59695 | |
| 1 | 59695 | |
| 6 | 28375 | |
| 7 | 20274 | 8.5% |
| 5 | 11046 | 4.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 238780 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 2 | 59695 | |
| 0 | 59695 | |
| 1 | 59695 | |
| 6 | 28375 | |
| 7 | 20274 | 8.5% |
| 5 | 11046 | 4.6% |
ArrivalDateMonth
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| August | |
|---|---|
| July | |
| May | |
| October | |
| April | |
| Other values (7) |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 5.904028813 |
| Min length | 3 |
Characters and Unicode
| Total characters | 352441 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | July |
|---|---|
| 2nd row | April |
| 3rd row | February |
| 4th row | October |
| 5th row | July |
| Value | Count | Frequency (%) |
| August | 6916 | |
| July | 6302 | |
| May | 5931 | |
| October | 5589 | |
| April | 5535 | |
| June | 5448 | |
| September | 5238 | |
| March | 4908 | |
| February | 4099 | |
| December | 3419 | |
| Other values (2) | 6310 |
| Value | Count | Frequency (%) |
| august | 6916 | |
| july | 6302 | |
| may | 5931 | |
| october | 5589 | |
| april | 5535 | |
| june | 5448 | |
| september | 5238 | |
| march | 4908 | |
| february | 4099 | |
| december | 3419 | |
| Other values (2) | 6310 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 47823 | |
| r | 39197 | 11.1% |
| u | 32633 | 9.3% |
| b | 21703 | 6.2% |
| a | 20842 | 5.9% |
| y | 19284 | 5.5% |
| t | 17743 | 5.0% |
| J | 14702 | 4.2% |
| c | 13916 | 3.9% |
| A | 12451 | 3.5% |
| Other values (16) | 112147 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 292746 | |
| Uppercase Letter | 59695 | 16.9% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 47823 | |
| r | 39197 | |
| u | 32633 | |
| b | 21703 | 7.4% |
| a | 20842 | 7.1% |
| y | 19284 | 6.6% |
| t | 17743 | 6.1% |
| c | 13916 | 4.8% |
| m | 12015 | 4.1% |
| l | 11837 | 4.0% |
| Other values (8) | 55753 |
| Value | Count | Frequency (%) |
| J | 14702 | |
| A | 12451 | |
| M | 10839 | |
| O | 5589 | 9.4% |
| S | 5238 | 8.8% |
| F | 4099 | 6.9% |
| D | 3419 | 5.7% |
| N | 3358 | 5.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 352441 |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 47823 | |
| r | 39197 | 11.1% |
| u | 32633 | 9.3% |
| b | 21703 | 6.2% |
| a | 20842 | 5.9% |
| y | 19284 | 5.5% |
| t | 17743 | 5.0% |
| J | 14702 | 4.2% |
| c | 13916 | 3.9% |
| A | 12451 | 3.5% |
| Other values (16) | 112147 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 352441 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 47823 | |
| r | 39197 | 11.1% |
| u | 32633 | 9.3% |
| b | 21703 | 6.2% |
| a | 20842 | 5.9% |
| y | 19284 | 5.5% |
| t | 17743 | 5.0% |
| J | 14702 | 4.2% |
| c | 13916 | 3.9% |
| A | 12451 | 3.5% |
| Other values (16) | 112147 |
ArrivalDateWeekNumber
Real number (ℝ≥0)
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.13991122 |
|---|---|
| Minimum | 1 |
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 466.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 16 |
| median | 28 |
| Q3 | 38 |
| 95-th percentile | 49 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 13.62353557 |
|---|---|
| Coefficient of variation (CV) | 0.5019742128 |
| Kurtosis | -0.9895419997 |
| Mean | 27.13991122 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | -0.005445386918 |
| Sum | 1620117 |
| Variance | 185.6007214 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 33 | 1791 | 3.0% |
| 32 | 1517 | 2.5% |
| 30 | 1513 | 2.5% |
| 18 | 1483 | 2.5% |
| 21 | 1471 | 2.5% |
| 34 | 1462 | 2.4% |
| 28 | 1417 | 2.4% |
| 29 | 1415 | 2.4% |
| 17 | 1412 | 2.4% |
| 31 | 1408 | 2.4% |
| Other values (43) | 44806 |
| Value | Count | Frequency (%) |
| 1 | 524 | |
| 2 | 618 | |
| 3 | 656 | |
| 4 | 733 | |
| 5 | 694 |
| Value | Count | Frequency (%) |
| 53 | 933 | |
| 52 | 589 | |
| 51 | 476 | |
| 50 | 728 | |
| 49 | 930 |
ArrivalDateDayOfMonth
Real number (ℝ≥0)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.79656588 |
|---|---|
| Minimum | 1 |
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 466.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.782652219 |
|---|---|
| Coefficient of variation (CV) | 0.5559849076 |
| Kurtosis | -1.186781255 |
| Mean | 15.79656588 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.0003471236631 |
| Sum | 942976 |
| Variance | 77.13498 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 17 | 2257 | 3.8% |
| 5 | 2196 | 3.7% |
| 15 | 2106 | 3.5% |
| 9 | 2065 | 3.5% |
| 26 | 2054 | 3.4% |
| 25 | 2048 | 3.4% |
| 2 | 2039 | 3.4% |
| 12 | 2028 | 3.4% |
| 16 | 2013 | 3.4% |
| 18 | 2006 | 3.4% |
| Other values (21) | 38883 |
| Value | Count | Frequency (%) |
| 1 | 1786 | |
| 2 | 2039 | |
| 3 | 1944 | |
| 4 | 1856 | |
| 5 | 2196 |
| Value | Count | Frequency (%) |
| 31 | 1105 | |
| 30 | 1972 | |
| 29 | 1775 | |
| 28 | 1951 | |
| 27 | 1939 |
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.9307144652 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros | 25912 |
| Zeros (%) | 43.4% |
| Memory size | 466.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 0.9994422929 |
|---|---|
| Coefficient of variation (CV) | 1.07384416 |
| Kurtosis | 5.610020657 |
| Mean | 0.9307144652 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.315806974 |
| Sum | 55559 |
| Variance | 0.9988848968 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 25912 | |
| 2 | 16676 | |
| 1 | 15352 | |
| 4 | 918 | 1.5% |
| 3 | 651 | 1.1% |
| 6 | 81 | 0.1% |
| 5 | 46 | 0.1% |
| 8 | 33 | 0.1% |
| 7 | 8 | < 0.1% |
| 9 | 7 | < 0.1% |
| Other values (5) | 11 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 25912 | |
| 1 | 15352 | |
| 2 | 16676 | |
| 3 | 651 | 1.1% |
| 4 | 918 | 1.5% |
| Value | Count | Frequency (%) |
| 16 | 1 | < 0.1% |
| 14 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 12 | 4 | |
| 10 | 4 |
| Distinct | 30 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.502119105 |
|---|---|
| Minimum | 0 |
| Maximum | 41 |
| Zeros | 3814 |
| Zeros (%) | 6.4% |
| Memory size | 466.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 41 |
| Range | 41 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.909964042 |
|---|---|
| Coefficient of variation (CV) | 0.7633385788 |
| Kurtosis | 19.67455136 |
| Mean | 2.502119105 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.719199321 |
| Sum | 149364 |
| Variance | 3.647962642 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 16856 | |
| 1 | 15189 | |
| 3 | 11012 | |
| 5 | 5531 | 9.3% |
| 4 | 4848 | 8.1% |
| 0 | 3814 | 6.4% |
| 6 | 750 | 1.3% |
| 7 | 532 | 0.9% |
| 10 | 495 | 0.8% |
| 8 | 334 | 0.6% |
| Other values (20) | 334 | 0.6% |
| Value | Count | Frequency (%) |
| 0 | 3814 | 6.4% |
| 1 | 15189 | |
| 2 | 16856 | |
| 3 | 11012 | |
| 4 | 4848 | 8.1% |
| Value | Count | Frequency (%) |
| 41 | 1 | < 0.1% |
| 35 | 1 | < 0.1% |
| 32 | 1 | < 0.1% |
| 30 | 3 | |
| 26 | 1 | < 0.1% |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.859452215 |
|---|---|
| Minimum | 0 |
| Maximum | 55 |
| Zeros | 217 |
| Zeros (%) | 0.4% |
| Memory size | 466.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 55 |
| Range | 55 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.597186927 |
|---|---|
| Coefficient of variation (CV) | 0.3211628253 |
| Kurtosis | 1529.296426 |
| Mean | 1.859452215 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 20.93767433 |
| Sum | 111000 |
| Variance | 0.3566322258 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 44911 | |
| 1 | 11378 | 19.1% |
| 3 | 3151 | 5.3% |
| 0 | 217 | 0.4% |
| 4 | 29 | < 0.1% |
| 26 | 3 | < 0.1% |
| 27 | 1 | < 0.1% |
| 55 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| Other values (2) | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 217 | 0.4% |
| 1 | 11378 | 19.1% |
| 2 | 44911 | |
| 3 | 3151 | 5.3% |
| 4 | 29 | < 0.1% |
| Value | Count | Frequency (%) |
| 55 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 26 | 3 | |
| 20 | 1 | < 0.1% |
Children
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| 0.0 | |
|---|---|
| 1.0 | 2422 |
| 2.0 | 1893 |
| 3.0 | 30 |
| nan | 4 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 179085 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 2.0 |
| Value | Count | Frequency (%) |
| 0.0 | 55346 | |
| 1.0 | 2422 | 4.1% |
| 2.0 | 1893 | 3.2% |
| 3.0 | 30 | 0.1% |
| nan | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.0 | 55346 | |
| 1.0 | 2422 | 4.1% |
| 2.0 | 1893 | 3.2% |
| 3.0 | 30 | 0.1% |
| nan | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 115037 | |
| . | 59691 | |
| 1 | 2422 | 1.4% |
| 2 | 1893 | 1.1% |
| 3 | 30 | < 0.1% |
| n | 8 | < 0.1% |
| a | 4 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 119382 | |
| Other Punctuation | 59691 | |
| Lowercase Letter | 12 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 115037 | |
| 1 | 2422 | 2.0% |
| 2 | 1893 | 1.6% |
| 3 | 30 | < 0.1% |
| Value | Count | Frequency (%) |
| n | 8 | |
| a | 4 |
| Value | Count | Frequency (%) |
| . | 59691 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 179073 | |
| Latin | 12 | < 0.1% |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 115037 | |
| . | 59691 | |
| 1 | 2422 | 1.4% |
| 2 | 1893 | 1.1% |
| 3 | 30 | < 0.1% |
| Value | Count | Frequency (%) |
| n | 8 | |
| a | 4 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 179085 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 115037 | |
| . | 59691 | |
| 1 | 2422 | 1.4% |
| 2 | 1893 | 1.1% |
| 3 | 30 | < 0.1% |
| n | 8 | < 0.1% |
| a | 4 | < 0.1% |
Babies
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| 0 | |
|---|---|
| 1 | 458 |
| 2 | 8 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 59695 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 59229 | |
| 1 | 458 | 0.8% |
| 2 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 59229 | |
| 1 | 458 | 0.8% |
| 2 | 8 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 59229 | |
| 1 | 458 | 0.8% |
| 2 | 8 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 59695 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 59229 | |
| 1 | 458 | 0.8% |
| 2 | 8 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 59695 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 59229 | |
| 1 | 458 | 0.8% |
| 2 | 8 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 59695 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 59229 | |
| 1 | 458 | 0.8% |
| 2 | 8 | < 0.1% |
Meal
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| BB | |
|---|---|
| HB | |
| SC | |
| Undefined | 598 |
| FB | 408 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 537255 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FB |
|---|---|
| 2nd row | HB |
| 3rd row | BB |
| 4th row | BB |
| 5th row | BB |
| Value | Count | Frequency (%) |
| BB | 46118 | |
| HB | 7262 | 12.2% |
| SC | 5309 | 8.9% |
| Undefined | 598 | 1.0% |
| FB | 408 | 0.7% |
| Value | Count | Frequency (%) |
| bb | 46118 | |
| hb | 7262 | 12.2% |
| sc | 5309 | 8.9% |
| undefined | 598 | 1.0% |
| fb | 408 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 413679 | ||
| B | 99906 | 18.6% |
| H | 7262 | 1.4% |
| S | 5309 | 1.0% |
| C | 5309 | 1.0% |
| n | 1196 | 0.2% |
| d | 1196 | 0.2% |
| e | 1196 | 0.2% |
| U | 598 | 0.1% |
| f | 598 | 0.1% |
| Other values (2) | 1006 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 413679 | |
| Uppercase Letter | 118792 | 22.1% |
| Lowercase Letter | 4784 | 0.9% |
Most frequent character per category
| Value | Count | Frequency (%) |
| B | 99906 | |
| H | 7262 | 6.1% |
| S | 5309 | 4.5% |
| C | 5309 | 4.5% |
| U | 598 | 0.5% |
| F | 408 | 0.3% |
| Value | Count | Frequency (%) |
| n | 1196 | |
| d | 1196 | |
| e | 1196 | |
| f | 598 | |
| i | 598 |
| Value | Count | Frequency (%) |
| 413679 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 413679 | |
| Latin | 123576 | 23.0% |
Most frequent character per script
| Value | Count | Frequency (%) |
| B | 99906 | |
| H | 7262 | 5.9% |
| S | 5309 | 4.3% |
| C | 5309 | 4.3% |
| n | 1196 | 1.0% |
| d | 1196 | 1.0% |
| e | 1196 | 1.0% |
| U | 598 | 0.5% |
| f | 598 | 0.5% |
| i | 598 | 0.5% |
| Value | Count | Frequency (%) |
| 413679 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 537255 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 413679 | ||
| B | 99906 | 18.6% |
| H | 7262 | 1.4% |
| S | 5309 | 1.0% |
| C | 5309 | 1.0% |
| n | 1196 | 0.2% |
| d | 1196 | 0.2% |
| e | 1196 | 0.2% |
| U | 598 | 0.1% |
| f | 598 | 0.1% |
| Other values (2) | 1006 | 0.2% |
| Distinct | 155 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 236 |
| Missing (%) | 0.4% |
| Memory size | 466.5 KiB |
| PRT | |
|---|---|
| GBR | |
| FRA | |
| ESP | |
| DEU | |
| Other values (150) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.989370827 |
| Min length | 2 |
Characters and Unicode
| Total characters | 177745 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 27 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PRT |
|---|---|
| 2nd row | PRT |
| 3rd row | GBR |
| 4th row | PRT |
| 5th row | GBR |
| Value | Count | Frequency (%) |
| PRT | 24171 | |
| GBR | 6125 | 10.3% |
| FRA | 5217 | 8.7% |
| ESP | 4275 | 7.2% |
| DEU | 3600 | 6.0% |
| ITA | 1856 | 3.1% |
| IRL | 1665 | 2.8% |
| BEL | 1243 | 2.1% |
| BRA | 1135 | 1.9% |
| NLD | 1065 | 1.8% |
| Other values (145) | 9107 | 15.3% |
| Value | Count | Frequency (%) |
| prt | 24171 | |
| gbr | 6125 | 10.3% |
| fra | 5217 | 8.8% |
| esp | 4275 | 7.2% |
| deu | 3600 | 6.1% |
| ita | 1856 | 3.1% |
| irl | 1665 | 2.8% |
| bel | 1243 | 2.1% |
| bra | 1135 | 1.9% |
| nld | 1065 | 1.8% |
| Other values (145) | 9107 | 15.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 40360 | |
| P | 29139 | |
| T | 26982 | |
| A | 10838 | 6.1% |
| E | 10806 | 6.1% |
| B | 8672 | 4.9% |
| S | 6966 | 3.9% |
| G | 6651 | 3.7% |
| U | 6599 | 3.7% |
| F | 5484 | 3.1% |
| Other values (16) | 25248 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 177745 |
Most frequent character per category
| Value | Count | Frequency (%) |
| R | 40360 | |
| P | 29139 | |
| T | 26982 | |
| A | 10838 | 6.1% |
| E | 10806 | 6.1% |
| B | 8672 | 4.9% |
| S | 6966 | 3.9% |
| G | 6651 | 3.7% |
| U | 6599 | 3.7% |
| F | 5484 | 3.1% |
| Other values (16) | 25248 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 177745 |
Most frequent character per script
| Value | Count | Frequency (%) |
| R | 40360 | |
| P | 29139 | |
| T | 26982 | |
| A | 10838 | 6.1% |
| E | 10806 | 6.1% |
| B | 8672 | 4.9% |
| S | 6966 | 3.9% |
| G | 6651 | 3.7% |
| U | 6599 | 3.7% |
| F | 5484 | 3.1% |
| Other values (16) | 25248 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 177745 |
Most frequent character per block
| Value | Count | Frequency (%) |
| R | 40360 | |
| P | 29139 | |
| T | 26982 | |
| A | 10838 | 6.1% |
| E | 10806 | 6.1% |
| B | 8672 | 4.9% |
| S | 6966 | 3.9% |
| G | 6651 | 3.7% |
| U | 6599 | 3.7% |
| F | 5484 | 3.1% |
| Other values (16) | 25248 |
MarketSegment
Categorical
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| Online TA | |
|---|---|
| Offline TA/TO | |
| Groups | |
| Direct | |
| Corporate | 2656 |
| Other values (3) | 484 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.021224558 |
| Min length | 6 |
Characters and Unicode
| Total characters | 538522 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Groups |
|---|---|
| 2nd row | Groups |
| 3rd row | Offline TA/TO |
| 4th row | Online TA |
| 5th row | Online TA |
| Value | Count | Frequency (%) |
| Online TA | 28322 | |
| Offline TA/TO | 12084 | |
| Groups | 9826 | 16.5% |
| Direct | 6323 | 10.6% |
| Corporate | 2656 | 4.4% |
| Complementary | 372 | 0.6% |
| Aviation | 110 | 0.2% |
| Undefined | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| online | 28322 | |
| ta | 28322 | |
| ta/to | 12084 | |
| offline | 12084 | |
| groups | 9826 | 9.8% |
| direct | 6323 | 6.3% |
| corporate | 2656 | 2.7% |
| complementary | 372 | 0.4% |
| aviation | 110 | 0.1% |
| undefined | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 69214 | |
| O | 52490 | |
| T | 52490 | |
| e | 50133 | |
| i | 46951 | |
| l | 40778 | |
| A | 40516 | |
| 40406 | ||
| f | 24170 | 4.5% |
| r | 21833 | 4.1% |
| Other values (16) | 99541 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 321357 | |
| Uppercase Letter | 164675 | |
| Space Separator | 40406 | 7.5% |
| Other Punctuation | 12084 | 2.2% |
Most frequent character per category
| Value | Count | Frequency (%) |
| n | 69214 | |
| e | 50133 | |
| i | 46951 | |
| l | 40778 | |
| f | 24170 | 7.5% |
| r | 21833 | 6.8% |
| o | 15620 | 4.9% |
| p | 12854 | 4.0% |
| u | 9826 | 3.1% |
| s | 9826 | 3.1% |
| Other values (7) | 20152 | 6.3% |
| Value | Count | Frequency (%) |
| O | 52490 | |
| T | 52490 | |
| A | 40516 | |
| G | 9826 | 6.0% |
| D | 6323 | 3.8% |
| C | 3028 | 1.8% |
| U | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 40406 |
| Value | Count | Frequency (%) |
| / | 12084 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 486032 | |
| Common | 52490 | 9.7% |
Most frequent character per script
| Value | Count | Frequency (%) |
| n | 69214 | |
| O | 52490 | |
| T | 52490 | |
| e | 50133 | |
| i | 46951 | |
| l | 40778 | |
| A | 40516 | |
| f | 24170 | 5.0% |
| r | 21833 | 4.5% |
| o | 15620 | 3.2% |
| Other values (14) | 71837 |
| Value | Count | Frequency (%) |
| 40406 | ||
| / | 12084 | 23.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 538522 |
Most frequent character per block
| Value | Count | Frequency (%) |
| n | 69214 | |
| O | 52490 | |
| T | 52490 | |
| e | 50133 | |
| i | 46951 | |
| l | 40778 | |
| A | 40516 | |
| 40406 | ||
| f | 24170 | 4.5% |
| r | 21833 | 4.1% |
| Other values (16) | 99541 |
DistributionChannel
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| TA/TO | |
|---|---|
| Direct | |
| Corporate | 3341 |
| GDS | 89 |
| Undefined | 5 |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.344249937 |
| Min length | 3 |
Characters and Unicode
| Total characters | 319025 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Direct |
|---|---|
| 2nd row | TA/TO |
| 3rd row | TA/TO |
| 4th row | TA/TO |
| 5th row | TA/TO |
| Value | Count | Frequency (%) |
| TA/TO | 48916 | |
| Direct | 7344 | 12.3% |
| Corporate | 3341 | 5.6% |
| GDS | 89 | 0.1% |
| Undefined | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| ta/to | 48916 | |
| direct | 7344 | 12.3% |
| corporate | 3341 | 5.6% |
| gds | 89 | 0.1% |
| undefined | 5 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 97832 | |
| A | 48916 | |
| / | 48916 | |
| O | 48916 | |
| r | 14026 | 4.4% |
| e | 10695 | 3.4% |
| t | 10685 | 3.3% |
| D | 7433 | 2.3% |
| i | 7349 | 2.3% |
| c | 7344 | 2.3% |
| Other values (10) | 16913 | 5.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 206621 | |
| Lowercase Letter | 63488 | 19.9% |
| Other Punctuation | 48916 | 15.3% |
Most frequent character per category
| Value | Count | Frequency (%) |
| r | 14026 | |
| e | 10695 | |
| t | 10685 | |
| i | 7349 | |
| c | 7344 | |
| o | 6682 | |
| p | 3341 | 5.3% |
| a | 3341 | 5.3% |
| n | 10 | < 0.1% |
| d | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| T | 97832 | |
| A | 48916 | |
| O | 48916 | |
| D | 7433 | 3.6% |
| C | 3341 | 1.6% |
| G | 89 | < 0.1% |
| S | 89 | < 0.1% |
| U | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| / | 48916 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 270109 | |
| Common | 48916 | 15.3% |
Most frequent character per script
| Value | Count | Frequency (%) |
| T | 97832 | |
| A | 48916 | |
| O | 48916 | |
| r | 14026 | 5.2% |
| e | 10695 | 4.0% |
| t | 10685 | 4.0% |
| D | 7433 | 2.8% |
| i | 7349 | 2.7% |
| c | 7344 | 2.7% |
| o | 6682 | 2.5% |
| Other values (9) | 10231 | 3.8% |
| Value | Count | Frequency (%) |
| / | 48916 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 319025 |
Most frequent character per block
| Value | Count | Frequency (%) |
| T | 97832 | |
| A | 48916 | |
| / | 48916 | |
| O | 48916 | |
| r | 14026 | 4.4% |
| e | 10695 | 3.4% |
| t | 10685 | 3.3% |
| D | 7433 | 2.3% |
| i | 7349 | 2.3% |
| c | 7344 | 2.3% |
| Other values (10) | 16913 | 5.3% |
IsRepeatedGuest
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| 0 | |
|---|---|
| 1 | 1958 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 59695 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 57737 | |
| 1 | 1958 | 3.3% |
| Value | Count | Frequency (%) |
| 0 | 57737 | |
| 1 | 1958 | 3.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 57737 | |
| 1 | 1958 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 59695 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 57737 | |
| 1 | 1958 | 3.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 59695 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 57737 | |
| 1 | 1958 | 3.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 59695 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 57737 | |
| 1 | 1958 | 3.3% |
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.088064327 |
|---|---|
| Minimum | 0 |
| Maximum | 26 |
| Zeros | 56480 |
| Zeros (%) | 94.6% |
| Memory size | 466.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.8557465581 |
|---|---|
| Coefficient of variation (CV) | 9.717289477 |
| Kurtosis | 649.0697173 |
| Mean | 0.088064327 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 23.97962684 |
| Sum | 5257 |
| Variance | 0.7323021716 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 56480 | |
| 1 | 2987 | 5.0% |
| 2 | 65 | 0.1% |
| 3 | 31 | 0.1% |
| 11 | 21 | < 0.1% |
| 24 | 20 | < 0.1% |
| 25 | 16 | < 0.1% |
| 5 | 14 | < 0.1% |
| 26 | 13 | < 0.1% |
| 19 | 12 | < 0.1% |
| Other values (4) | 36 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 56480 | |
| 1 | 2987 | 5.0% |
| 2 | 65 | 0.1% |
| 3 | 31 | 0.1% |
| 4 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 26 | 13 | |
| 25 | 16 | |
| 24 | 20 | |
| 19 | 12 | |
| 14 | 6 | < 0.1% |
| Distinct | 55 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.136745121 |
|---|---|
| Minimum | 0 |
| Maximum | 70 |
| Zeros | 57855 |
| Zeros (%) | 96.9% |
| Memory size | 466.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 70 |
| Range | 70 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.487479995 |
|---|---|
| Coefficient of variation (CV) | 10.87775552 |
| Kurtosis | 751.5324858 |
| Mean | 0.136745121 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 23.41816044 |
| Sum | 8163 |
| Variance | 2.212596736 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 57855 | |
| 1 | 803 | 1.3% |
| 2 | 299 | 0.5% |
| 3 | 155 | 0.3% |
| 4 | 115 | 0.2% |
| 5 | 95 | 0.2% |
| 6 | 54 | 0.1% |
| 7 | 43 | 0.1% |
| 8 | 35 | 0.1% |
| 9 | 30 | 0.1% |
| Other values (45) | 211 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 57855 | |
| 1 | 803 | 1.3% |
| 2 | 299 | 0.5% |
| 3 | 155 | 0.3% |
| 4 | 115 | 0.2% |
| Value | Count | Frequency (%) |
| 70 | 1 | |
| 68 | 1 | |
| 64 | 1 | |
| 63 | 1 | |
| 61 | 1 |
ReservedRoomType
Categorical
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| A | |
|---|---|
| D | |
| E | 3257 |
| F | 1479 |
| G | 1053 |
| Other values (5) | 1396 |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 16 |
| Min length | 16 |
Characters and Unicode
| Total characters | 955120 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | B |
| Value | Count | Frequency (%) |
| A | 42831 | |
| D | 9679 | 16.2% |
| E | 3257 | 5.5% |
| F | 1479 | 2.5% |
| G | 1053 | 1.8% |
| B | 608 | 1.0% |
| C | 473 | 0.8% |
| H | 307 | 0.5% |
| L | 5 | < 0.1% |
| P | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| a | 42831 | |
| d | 9679 | 16.2% |
| e | 3257 | 5.5% |
| f | 1479 | 2.5% |
| g | 1053 | 1.8% |
| b | 608 | 1.0% |
| c | 473 | 0.8% |
| h | 307 | 0.5% |
| l | 5 | < 0.1% |
| p | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 895425 | ||
| A | 42831 | 4.5% |
| D | 9679 | 1.0% |
| E | 3257 | 0.3% |
| F | 1479 | 0.2% |
| G | 1053 | 0.1% |
| B | 608 | 0.1% |
| C | 473 | < 0.1% |
| H | 307 | < 0.1% |
| L | 5 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 895425 | |
| Uppercase Letter | 59695 | 6.2% |
Most frequent character per category
| Value | Count | Frequency (%) |
| A | 42831 | |
| D | 9679 | 16.2% |
| E | 3257 | 5.5% |
| F | 1479 | 2.5% |
| G | 1053 | 1.8% |
| B | 608 | 1.0% |
| C | 473 | 0.8% |
| H | 307 | 0.5% |
| L | 5 | < 0.1% |
| P | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 895425 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 895425 | |
| Latin | 59695 | 6.2% |
Most frequent character per script
| Value | Count | Frequency (%) |
| A | 42831 | |
| D | 9679 | 16.2% |
| E | 3257 | 5.5% |
| F | 1479 | 2.5% |
| G | 1053 | 1.8% |
| B | 608 | 1.0% |
| C | 473 | 0.8% |
| H | 307 | 0.5% |
| L | 5 | < 0.1% |
| P | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 895425 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 955120 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 895425 | ||
| A | 42831 | 4.5% |
| D | 9679 | 1.0% |
| E | 3257 | 0.3% |
| F | 1479 | 0.2% |
| G | 1053 | 0.1% |
| B | 608 | 0.1% |
| C | 473 | < 0.1% |
| H | 307 | < 0.1% |
| L | 5 | < 0.1% |
AssignedRoomType
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| A | |
|---|---|
| D | |
| E | |
| F | 1948 |
| G | 1280 |
| Other values (7) | 2973 |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 16 |
| Min length | 16 |
Characters and Unicode
| Total characters | 955120 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | D |
| 4th row | A |
| 5th row | B |
| Value | Count | Frequency (%) |
| A | 36878 | |
| D | 12736 | 21.3% |
| E | 3880 | 6.5% |
| F | 1948 | 3.3% |
| G | 1280 | 2.1% |
| C | 1207 | 2.0% |
| B | 1081 | 1.8% |
| H | 371 | 0.6% |
| I | 167 | 0.3% |
| K | 143 | 0.2% |
| Other values (2) | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| a | 36878 | |
| d | 12736 | 21.3% |
| e | 3880 | 6.5% |
| f | 1948 | 3.3% |
| g | 1280 | 2.1% |
| c | 1207 | 2.0% |
| b | 1081 | 1.8% |
| h | 371 | 0.6% |
| i | 167 | 0.3% |
| k | 143 | 0.2% |
| Other values (2) | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 895425 | ||
| A | 36878 | 3.9% |
| D | 12736 | 1.3% |
| E | 3880 | 0.4% |
| F | 1948 | 0.2% |
| G | 1280 | 0.1% |
| C | 1207 | 0.1% |
| B | 1081 | 0.1% |
| H | 371 | < 0.1% |
| I | 167 | < 0.1% |
| Other values (3) | 147 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 895425 | |
| Uppercase Letter | 59695 | 6.2% |
Most frequent character per category
| Value | Count | Frequency (%) |
| A | 36878 | |
| D | 12736 | 21.3% |
| E | 3880 | 6.5% |
| F | 1948 | 3.3% |
| G | 1280 | 2.1% |
| C | 1207 | 2.0% |
| B | 1081 | 1.8% |
| H | 371 | 0.6% |
| I | 167 | 0.3% |
| K | 143 | 0.2% |
| Other values (2) | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 895425 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 895425 | |
| Latin | 59695 | 6.2% |
Most frequent character per script
| Value | Count | Frequency (%) |
| A | 36878 | |
| D | 12736 | 21.3% |
| E | 3880 | 6.5% |
| F | 1948 | 3.3% |
| G | 1280 | 2.1% |
| C | 1207 | 2.0% |
| B | 1081 | 1.8% |
| H | 371 | 0.6% |
| I | 167 | 0.3% |
| K | 143 | 0.2% |
| Other values (2) | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 895425 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 955120 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 895425 | ||
| A | 36878 | 3.9% |
| D | 12736 | 1.3% |
| E | 3880 | 0.4% |
| F | 1948 | 0.2% |
| G | 1280 | 0.1% |
| C | 1207 | 0.1% |
| B | 1081 | 0.1% |
| H | 371 | < 0.1% |
| I | 167 | < 0.1% |
| Other values (3) | 147 | < 0.1% |
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2225982076 |
|---|---|
| Minimum | 0 |
| Maximum | 21 |
| Zeros | 50647 |
| Zeros (%) | 84.8% |
| Memory size | 466.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6667099906 |
|---|---|
| Coefficient of variation (CV) | 2.9951274 |
| Kurtosis | 95.18461672 |
| Mean | 0.2225982076 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.561586101 |
| Sum | 13288 |
| Variance | 0.4445022116 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 50647 | |
| 1 | 6345 | 10.6% |
| 2 | 1924 | 3.2% |
| 3 | 453 | 0.8% |
| 4 | 185 | 0.3% |
| 5 | 52 | 0.1% |
| 6 | 41 | 0.1% |
| 7 | 15 | < 0.1% |
| 8 | 9 | < 0.1% |
| 10 | 5 | < 0.1% |
| Other values (10) | 19 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 50647 | |
| 1 | 6345 | 10.6% |
| 2 | 1924 | 3.2% |
| 3 | 453 | 0.8% |
| 4 | 185 | 0.3% |
| Value | Count | Frequency (%) |
| 21 | 1 | |
| 20 | 1 | |
| 18 | 1 | |
| 16 | 1 | |
| 15 | 2 |
DepositType
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| No Deposit | |
|---|---|
| Non Refund | |
| Refundable | 85 |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Characters and Unicode
| Total characters | 895425 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Deposit |
|---|---|
| 2nd row | No Deposit |
| 3rd row | No Deposit |
| 4th row | No Deposit |
| 5th row | No Deposit |
| Value | Count | Frequency (%) |
| No Deposit | 52453 | |
| Non Refund | 7157 | 12.0% |
| Refundable | 85 | 0.1% |
| Value | Count | Frequency (%) |
| no | 52453 | |
| deposit | 52453 | |
| refund | 7157 | 6.0% |
| non | 7157 | 6.0% |
| refundable | 85 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 358085 | ||
| o | 112063 | 12.5% |
| e | 59780 | 6.7% |
| N | 59610 | 6.7% |
| D | 52453 | 5.9% |
| p | 52453 | 5.9% |
| s | 52453 | 5.9% |
| i | 52453 | 5.9% |
| t | 52453 | 5.9% |
| n | 14399 | 1.6% |
| Other values (7) | 29223 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 418035 | |
| Space Separator | 358085 | |
| Uppercase Letter | 119305 | 13.3% |
Most frequent character per category
| Value | Count | Frequency (%) |
| o | 112063 | |
| e | 59780 | |
| p | 52453 | |
| s | 52453 | |
| i | 52453 | |
| t | 52453 | |
| n | 14399 | 3.4% |
| f | 7242 | 1.7% |
| u | 7242 | 1.7% |
| d | 7242 | 1.7% |
| Other values (3) | 255 | 0.1% |
| Value | Count | Frequency (%) |
| N | 59610 | |
| D | 52453 | |
| R | 7242 | 6.1% |
| Value | Count | Frequency (%) |
| 358085 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 537340 | |
| Common | 358085 |
Most frequent character per script
| Value | Count | Frequency (%) |
| o | 112063 | |
| e | 59780 | |
| N | 59610 | |
| D | 52453 | |
| p | 52453 | |
| s | 52453 | |
| i | 52453 | |
| t | 52453 | |
| n | 14399 | 2.7% |
| R | 7242 | 1.3% |
| Other values (6) | 21981 | 4.1% |
| Value | Count | Frequency (%) |
| 358085 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 895425 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 358085 | ||
| o | 112063 | 12.5% |
| e | 59780 | 6.7% |
| N | 59610 | 6.7% |
| D | 52453 | 5.9% |
| p | 52453 | 5.9% |
| s | 52453 | 5.9% |
| i | 52453 | 5.9% |
| t | 52453 | 5.9% |
| n | 14399 | 1.6% |
| Other values (7) | 29223 | 3.3% |
| Distinct | 296 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| 9 | |
|---|---|
| NULL | |
| 240 | |
| 1 | |
| 14 | 1810 |
| Other values (291) |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Characters and Unicode
| Total characters | 656645 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 41 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 305 |
|---|---|
| 2nd row | NULL |
| 3rd row | 6 |
| 4th row | 240 |
| 5th row | 9 |
| Value | Count | Frequency (%) |
| 9 | 16128 | |
| NULL | 8161 | |
| 240 | 6923 | |
| 1 | 3585 | 6.0% |
| 14 | 1810 | 3.0% |
| 7 | 1766 | 3.0% |
| 6 | 1653 | 2.8% |
| 250 | 1398 | 2.3% |
| 241 | 844 | 1.4% |
| 28 | 797 | 1.3% |
| Other values (286) | 16630 |
| Value | Count | Frequency (%) |
| 9 | 16128 | |
| null | 8161 | |
| 240 | 6923 | |
| 1 | 3585 | 6.0% |
| 14 | 1810 | 3.0% |
| 7 | 1766 | 3.0% |
| 6 | 1653 | 2.8% |
| 250 | 1398 | 2.3% |
| 241 | 844 | 1.4% |
| 28 | 797 | 1.3% |
| Other values (286) | 16630 |
Most occurring characters
| Value | Count | Frequency (%) |
| 529522 | ||
| 9 | 19250 | 2.9% |
| 2 | 16337 | 2.5% |
| L | 16322 | 2.5% |
| 4 | 13514 | 2.1% |
| 1 | 13360 | 2.0% |
| 0 | 10141 | 1.5% |
| N | 8161 | 1.2% |
| U | 8161 | 1.2% |
| 3 | 5429 | 0.8% |
| Other values (4) | 16448 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 529522 | |
| Decimal Number | 94479 | 14.4% |
| Uppercase Letter | 32644 | 5.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 9 | 19250 | |
| 2 | 16337 | |
| 4 | 13514 | |
| 1 | 13360 | |
| 0 | 10141 | |
| 3 | 5429 | 5.7% |
| 7 | 4316 | 4.6% |
| 5 | 4245 | 4.5% |
| 8 | 4040 | 4.3% |
| 6 | 3847 | 4.1% |
| Value | Count | Frequency (%) |
| L | 16322 | |
| N | 8161 | |
| U | 8161 |
| Value | Count | Frequency (%) |
| 529522 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 624001 | |
| Latin | 32644 | 5.0% |
Most frequent character per script
| Value | Count | Frequency (%) |
| 529522 | ||
| 9 | 19250 | 3.1% |
| 2 | 16337 | 2.6% |
| 4 | 13514 | 2.2% |
| 1 | 13360 | 2.1% |
| 0 | 10141 | 1.6% |
| 3 | 5429 | 0.9% |
| 7 | 4316 | 0.7% |
| 5 | 4245 | 0.7% |
| 8 | 4040 | 0.6% |
| Value | Count | Frequency (%) |
| L | 16322 | |
| N | 8161 | |
| U | 8161 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 656645 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 529522 | ||
| 9 | 19250 | 2.9% |
| 2 | 16337 | 2.5% |
| L | 16322 | 2.5% |
| 4 | 13514 | 2.1% |
| 1 | 13360 | 2.0% |
| 0 | 10141 | 1.5% |
| N | 8161 | 1.2% |
| U | 8161 | 1.2% |
| 3 | 5429 | 0.8% |
| Other values (4) | 16448 | 2.5% |
| Distinct | 287 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| NULL | |
|---|---|
| 40 | 459 |
| 223 | 384 |
| 45 | 129 |
| 67 | 120 |
| Other values (282) | 2286 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Characters and Unicode
| Total characters | 656645 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 80 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | NULL |
|---|---|
| 2nd row | NULL |
| 3rd row | NULL |
| 4th row | NULL |
| 5th row | NULL |
| Value | Count | Frequency (%) |
| NULL | 56317 | |
| 40 | 459 | 0.8% |
| 223 | 384 | 0.6% |
| 45 | 129 | 0.2% |
| 67 | 120 | 0.2% |
| 153 | 107 | 0.2% |
| 174 | 76 | 0.1% |
| 281 | 73 | 0.1% |
| 219 | 70 | 0.1% |
| 154 | 65 | 0.1% |
| Other values (277) | 1895 | 3.2% |
| Value | Count | Frequency (%) |
| null | 56317 | |
| 40 | 459 | 0.8% |
| 223 | 384 | 0.6% |
| 45 | 129 | 0.2% |
| 67 | 120 | 0.2% |
| 153 | 107 | 0.2% |
| 174 | 76 | 0.1% |
| 281 | 73 | 0.1% |
| 219 | 70 | 0.1% |
| 154 | 65 | 0.1% |
| Other values (277) | 1895 | 3.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 422435 | ||
| L | 112634 | 17.2% |
| N | 56317 | 8.6% |
| U | 56317 | 8.6% |
| 2 | 1658 | 0.3% |
| 4 | 1380 | 0.2% |
| 3 | 1306 | 0.2% |
| 1 | 1090 | 0.2% |
| 0 | 875 | 0.1% |
| 5 | 683 | 0.1% |
| Other values (4) | 1950 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 422435 | |
| Uppercase Letter | 225268 | |
| Decimal Number | 8942 | 1.4% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 2 | 1658 | |
| 4 | 1380 | |
| 3 | 1306 | |
| 1 | 1090 | |
| 0 | 875 | |
| 5 | 683 | |
| 7 | 553 | 6.2% |
| 8 | 518 | 5.8% |
| 9 | 468 | 5.2% |
| 6 | 411 | 4.6% |
| Value | Count | Frequency (%) |
| L | 112634 | |
| N | 56317 | |
| U | 56317 |
| Value | Count | Frequency (%) |
| 422435 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 431377 | |
| Latin | 225268 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 422435 | ||
| 2 | 1658 | 0.4% |
| 4 | 1380 | 0.3% |
| 3 | 1306 | 0.3% |
| 1 | 1090 | 0.3% |
| 0 | 875 | 0.2% |
| 5 | 683 | 0.2% |
| 7 | 553 | 0.1% |
| 8 | 518 | 0.1% |
| 9 | 468 | 0.1% |
| Value | Count | Frequency (%) |
| L | 112634 | |
| N | 56317 | |
| U | 56317 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 656645 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 422435 | ||
| L | 112634 | 17.2% |
| N | 56317 | 8.6% |
| U | 56317 | 8.6% |
| 2 | 1658 | 0.3% |
| 4 | 1380 | 0.2% |
| 3 | 1306 | 0.2% |
| 1 | 1090 | 0.2% |
| 0 | 875 | 0.1% |
| 5 | 683 | 0.1% |
| Other values (4) | 1950 | 0.3% |
| Distinct | 112 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.315319541 |
|---|---|
| Minimum | 0 |
| Maximum | 391 |
| Zeros | 57831 |
| Zeros (%) | 96.9% |
| Memory size | 466.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 391 |
| Range | 391 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 17.38291424 |
|---|---|
| Coefficient of variation (CV) | 7.507781942 |
| Kurtosis | 181.6806056 |
| Mean | 2.315319541 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.75749113 |
| Sum | 138213 |
| Variance | 302.1657074 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 57831 | |
| 39 | 113 | 0.2% |
| 58 | 83 | 0.1% |
| 44 | 73 | 0.1% |
| 31 | 67 | 0.1% |
| 35 | 49 | 0.1% |
| 50 | 46 | 0.1% |
| 62 | 42 | 0.1% |
| 46 | 40 | 0.1% |
| 38 | 38 | 0.1% |
| Other values (102) | 1313 | 2.2% |
| Value | Count | Frequency (%) |
| 0 | 57831 | |
| 1 | 6 | < 0.1% |
| 2 | 3 | < 0.1% |
| 3 | 32 | 0.1% |
| 4 | 14 | < 0.1% |
| Value | Count | Frequency (%) |
| 391 | 19 | |
| 379 | 8 | |
| 330 | 6 | < 0.1% |
| 259 | 7 | < 0.1% |
| 236 | 17 |
CustomerType
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| Transient | |
|---|---|
| Transient-Party | |
| Contract | 2064 |
| Group | 325 |
Length
| Max length | 15 |
|---|---|
| Median length | 9 |
| Mean length | 10.21531117 |
| Min length | 5 |
Characters and Unicode
| Total characters | 609803 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Transient-Party |
|---|---|
| 2nd row | Transient-Party |
| 3rd row | Transient |
| 4th row | Transient-Party |
| 5th row | Transient-Party |
| Value | Count | Frequency (%) |
| Transient | 44654 | |
| Transient-Party | 12652 | 21.2% |
| Contract | 2064 | 3.5% |
| Group | 325 | 0.5% |
| Value | Count | Frequency (%) |
| transient | 44654 | |
| transient-party | 12652 | 21.2% |
| contract | 2064 | 3.5% |
| group | 325 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 116676 | |
| t | 74086 | |
| r | 72347 | |
| a | 72022 | |
| T | 57306 | |
| s | 57306 | |
| i | 57306 | |
| e | 57306 | |
| - | 12652 | 2.1% |
| P | 12652 | 2.1% |
| Other values (7) | 20144 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 524804 | |
| Uppercase Letter | 72347 | 11.9% |
| Dash Punctuation | 12652 | 2.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| n | 116676 | |
| t | 74086 | |
| r | 72347 | |
| a | 72022 | |
| s | 57306 | |
| i | 57306 | |
| e | 57306 | |
| y | 12652 | 2.4% |
| o | 2389 | 0.5% |
| c | 2064 | 0.4% |
| Other values (2) | 650 | 0.1% |
| Value | Count | Frequency (%) |
| T | 57306 | |
| P | 12652 | 17.5% |
| C | 2064 | 2.9% |
| G | 325 | 0.4% |
| Value | Count | Frequency (%) |
| - | 12652 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 597151 | |
| Common | 12652 | 2.1% |
Most frequent character per script
| Value | Count | Frequency (%) |
| n | 116676 | |
| t | 74086 | |
| r | 72347 | |
| a | 72022 | |
| T | 57306 | |
| s | 57306 | |
| i | 57306 | |
| e | 57306 | |
| P | 12652 | 2.1% |
| y | 12652 | 2.1% |
| Other values (6) | 7492 | 1.3% |
| Value | Count | Frequency (%) |
| - | 12652 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 609803 |
Most frequent character per block
| Value | Count | Frequency (%) |
| n | 116676 | |
| t | 74086 | |
| r | 72347 | |
| a | 72022 | |
| T | 57306 | |
| s | 57306 | |
| i | 57306 | |
| e | 57306 | |
| - | 12652 | 2.1% |
| P | 12652 | 2.1% |
| Other values (7) | 20144 | 3.3% |
| Distinct | 6269 |
|---|---|
| Distinct (%) | 10.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 101.8662779 |
|---|---|
| Minimum | -6.38 |
| Maximum | 508 |
| Zeros | 967 |
| Zeros (%) | 1.6% |
| Memory size | 466.5 KiB |
Quantile statistics
| Minimum | -6.38 |
|---|---|
| 5-th percentile | 38.098 |
| Q1 | 69.52 |
| median | 94.5 |
| Q3 | 126 |
| 95-th percentile | 194 |
| Maximum | 508 |
| Range | 514.38 |
| Interquartile range (IQR) | 56.48 |
Descriptive statistics
| Standard deviation | 48.13930729 |
|---|---|
| Coefficient of variation (CV) | 0.4725735373 |
| Kurtosis | 2.044484037 |
| Mean | 101.8662779 |
| Median Absolute Deviation (MAD) | 27.9 |
| Skewness | 1.00229947 |
| Sum | 6080907.46 |
| Variance | 2317.392906 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 62 | 1871 | 3.1% |
| 75 | 1376 | 2.3% |
| 90 | 1278 | 2.1% |
| 65 | 1209 | 2.0% |
| 0 | 967 | 1.6% |
| 80 | 944 | 1.6% |
| 95 | 803 | 1.3% |
| 120 | 778 | 1.3% |
| 100 | 769 | 1.3% |
| 85 | 747 | 1.3% |
| Other values (6259) | 48953 |
| Value | Count | Frequency (%) |
| -6.38 | 1 | < 0.1% |
| 0 | 967 | |
| 0.26 | 1 | < 0.1% |
| 1 | 6 | < 0.1% |
| 1.8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 508 | 1 | |
| 451.5 | 1 | |
| 450 | 1 | |
| 397.38 | 1 | |
| 388 | 2 |
RequiredCarParkingSpaces
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| 0 | |
|---|---|
| 1 | 3659 |
| 2 | 13 |
| 3 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 59695 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 56022 | |
| 1 | 3659 | 6.1% |
| 2 | 13 | < 0.1% |
| 3 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 56022 | |
| 1 | 3659 | 6.1% |
| 2 | 13 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 56022 | |
| 1 | 3659 | 6.1% |
| 2 | 13 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 59695 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 56022 | |
| 1 | 3659 | 6.1% |
| 2 | 13 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 59695 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 56022 | |
| 1 | 3659 | 6.1% |
| 2 | 13 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 59695 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 56022 | |
| 1 | 3659 | 6.1% |
| 2 | 13 | < 0.1% |
| 3 | 1 | < 0.1% |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5722422313 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros | 35108 |
| Zeros (%) | 58.8% |
| Memory size | 466.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.7930812548 |
|---|---|
| Coefficient of variation (CV) | 1.38591878 |
| Kurtosis | 1.535222106 |
| Mean | 0.5722422313 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.352938301 |
| Sum | 34160 |
| Variance | 0.6289778768 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 35108 | |
| 1 | 16665 | |
| 2 | 6490 | 10.9% |
| 3 | 1237 | 2.1% |
| 4 | 171 | 0.3% |
| 5 | 24 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 35108 | |
| 1 | 16665 | |
| 2 | 6490 | 10.9% |
| 3 | 1237 | 2.1% |
| 4 | 171 | 0.3% |
| Value | Count | Frequency (%) |
| 5 | 24 | < 0.1% |
| 4 | 171 | 0.3% |
| 3 | 1237 | 2.1% |
| 2 | 6490 | 10.9% |
| 1 | 16665 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| Check-Out | |
|---|---|
| Canceled | |
| No-Show | 594 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.622229667 |
| Min length | 7 |
Characters and Unicode
| Total characters | 514704 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Check-Out |
|---|---|
| 2nd row | Canceled |
| 3rd row | Check-Out |
| 4th row | Check-Out |
| 5th row | Canceled |
| Value | Count | Frequency (%) |
| Check-Out | 37738 | |
| Canceled | 21363 | |
| No-Show | 594 | 1.0% |
| Value | Count | Frequency (%) |
| check-out | 37738 | |
| canceled | 21363 | |
| no-show | 594 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 80464 | |
| C | 59101 | |
| c | 59101 | |
| h | 38332 | |
| - | 38332 | |
| k | 37738 | |
| O | 37738 | |
| u | 37738 | |
| t | 37738 | |
| a | 21363 | 4.2% |
| Other values (7) | 67059 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 378345 | |
| Uppercase Letter | 98027 | 19.0% |
| Dash Punctuation | 38332 | 7.4% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 80464 | |
| c | 59101 | |
| h | 38332 | |
| k | 37738 | |
| u | 37738 | |
| t | 37738 | |
| a | 21363 | 5.6% |
| n | 21363 | 5.6% |
| l | 21363 | 5.6% |
| d | 21363 | 5.6% |
| Other values (2) | 1782 | 0.5% |
| Value | Count | Frequency (%) |
| C | 59101 | |
| O | 37738 | |
| N | 594 | 0.6% |
| S | 594 | 0.6% |
| Value | Count | Frequency (%) |
| - | 38332 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 476372 | |
| Common | 38332 | 7.4% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 80464 | |
| C | 59101 | |
| c | 59101 | |
| h | 38332 | |
| k | 37738 | |
| O | 37738 | |
| u | 37738 | |
| t | 37738 | |
| a | 21363 | 4.5% |
| n | 21363 | 4.5% |
| Other values (6) | 45696 |
| Value | Count | Frequency (%) |
| - | 38332 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 514704 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 80464 | |
| C | 59101 | |
| c | 59101 | |
| h | 38332 | |
| - | 38332 | |
| k | 37738 | |
| O | 37738 | |
| u | 37738 | |
| t | 37738 | |
| a | 21363 | 4.2% |
| Other values (7) | 67059 |
| Distinct | 902 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| 2015-10-21 | 730 |
|---|---|
| 2015-07-06 | 392 |
| 2016-11-25 | 387 |
| 2015-01-01 | 384 |
| 2016-01-18 | 318 |
| Other values (897) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 596950 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 27 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2015-07-17 |
|---|---|
| 2nd row | 2017-01-06 |
| 3rd row | 2016-02-16 |
| 4th row | 2016-10-11 |
| 5th row | 2016-02-20 |
| Value | Count | Frequency (%) |
| 2015-10-21 | 730 | 1.2% |
| 2015-07-06 | 392 | 0.7% |
| 2016-11-25 | 387 | 0.6% |
| 2015-01-01 | 384 | 0.6% |
| 2016-01-18 | 318 | 0.5% |
| 2015-07-02 | 231 | 0.4% |
| 2016-12-07 | 221 | 0.4% |
| 2015-12-18 | 214 | 0.4% |
| 2016-02-09 | 190 | 0.3% |
| 2016-04-04 | 189 | 0.3% |
| Other values (892) | 56439 |
| Value | Count | Frequency (%) |
| 2015-10-21 | 730 | 1.2% |
| 2015-07-06 | 392 | 0.7% |
| 2016-11-25 | 387 | 0.6% |
| 2015-01-01 | 384 | 0.6% |
| 2016-01-18 | 318 | 0.5% |
| 2015-07-02 | 231 | 0.4% |
| 2016-12-07 | 221 | 0.4% |
| 2015-12-18 | 214 | 0.4% |
| 2016-02-09 | 190 | 0.3% |
| 2016-04-04 | 189 | 0.3% |
| Other values (892) | 56439 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 135108 | |
| - | 119390 | |
| 1 | 109340 | |
| 2 | 93814 | |
| 6 | 39657 | 6.6% |
| 7 | 29956 | 5.0% |
| 5 | 23436 | 3.9% |
| 3 | 13436 | 2.3% |
| 8 | 11483 | 1.9% |
| 9 | 10783 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 477560 | |
| Dash Punctuation | 119390 | 20.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 135108 | |
| 1 | 109340 | |
| 2 | 93814 | |
| 6 | 39657 | 8.3% |
| 7 | 29956 | 6.3% |
| 5 | 23436 | 4.9% |
| 3 | 13436 | 2.8% |
| 8 | 11483 | 2.4% |
| 9 | 10783 | 2.3% |
| 4 | 10547 | 2.2% |
| Value | Count | Frequency (%) |
| - | 119390 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 596950 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 135108 | |
| - | 119390 | |
| 1 | 109340 | |
| 2 | 93814 | |
| 6 | 39657 | 6.6% |
| 7 | 29956 | 5.0% |
| 5 | 23436 | 3.9% |
| 3 | 13436 | 2.3% |
| 8 | 11483 | 1.9% |
| 9 | 10783 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 596950 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 135108 | |
| - | 119390 | |
| 1 | 109340 | |
| 2 | 93814 | |
| 6 | 39657 | 6.6% |
| 7 | 29956 | 5.0% |
| 5 | 23436 | 3.9% |
| 3 | 13436 | 2.3% |
| 8 | 11483 | 1.9% |
| 9 | 10783 | 1.8% |
Hotel
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 466.5 KiB |
| City Hotel | |
|---|---|
| Resort Hotel |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 10.67054192 |
| Min length | 10 |
Characters and Unicode
| Total characters | 636978 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Resort Hotel |
|---|---|
| 2nd row | Resort Hotel |
| 3rd row | Resort Hotel |
| 4th row | Resort Hotel |
| 5th row | City Hotel |
| Value | Count | Frequency (%) |
| City Hotel | 39681 | |
| Resort Hotel | 20014 |
| Value | Count | Frequency (%) |
| hotel | 59695 | |
| city | 39681 | |
| resort | 20014 | 16.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 119390 | |
| e | 79709 | |
| o | 79709 | |
| 59695 | ||
| H | 59695 | |
| l | 59695 | |
| C | 39681 | 6.2% |
| i | 39681 | 6.2% |
| y | 39681 | 6.2% |
| R | 20014 | 3.1% |
| Other values (2) | 40028 | 6.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 457893 | |
| Uppercase Letter | 119390 | 18.7% |
| Space Separator | 59695 | 9.4% |
Most frequent character per category
| Value | Count | Frequency (%) |
| t | 119390 | |
| e | 79709 | |
| o | 79709 | |
| l | 59695 | |
| i | 39681 | 8.7% |
| y | 39681 | 8.7% |
| s | 20014 | 4.4% |
| r | 20014 | 4.4% |
| Value | Count | Frequency (%) |
| H | 59695 | |
| C | 39681 | |
| R | 20014 | 16.8% |
| Value | Count | Frequency (%) |
| 59695 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 577283 | |
| Common | 59695 | 9.4% |
Most frequent character per script
| Value | Count | Frequency (%) |
| t | 119390 | |
| e | 79709 | |
| o | 79709 | |
| H | 59695 | |
| l | 59695 | |
| C | 39681 | 6.9% |
| i | 39681 | 6.9% |
| y | 39681 | 6.9% |
| R | 20014 | 3.5% |
| s | 20014 | 3.5% |
| Value | Count | Frequency (%) |
| 59695 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 636978 |
Most frequent character per block
| Value | Count | Frequency (%) |
| t | 119390 | |
| e | 79709 | |
| o | 79709 | |
| 59695 | ||
| H | 59695 | |
| l | 59695 | |
| C | 39681 | 6.2% |
| i | 39681 | 6.2% |
| y | 39681 | 6.2% |
| R | 20014 | 3.1% |
| Other values (2) | 40028 | 6.3% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | IsCanceled | LeadTime | ArrivalDateYear | ArrivalDateMonth | ArrivalDateWeekNumber | ArrivalDateDayOfMonth | StaysInWeekendNights | StaysInWeekNights | Adults | Children | Babies | Meal | Country | MarketSegment | DistributionChannel | IsRepeatedGuest | PreviousCancellations | PreviousBookingsNotCanceled | ReservedRoomType | AssignedRoomType | BookingChanges | DepositType | Agent | Company | DaysInWaitingList | CustomerType | ADR | RequiredCarParkingSpaces | TotalOfSpecialRequests | ReservationStatus | ReservationStatusDate | Hotel | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 429 | 0 | 57 | 2015 | July | 29 | 15 | 0 | 2 | 2 | 0.0 | 0 | FB | PRT | Groups | Direct | 0 | 0 | 0 | A | A | 0 | No Deposit | 305 | NULL | 0 | Transient-Party | 107.00 | 0 | 0 | Check-Out | 2015-07-17 | Resort Hotel |
| 1 | 11165 | 1 | 203 | 2017 | April | 17 | 25 | 0 | 2 | 2 | 0.0 | 0 | HB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | NULL | NULL | 0 | Transient-Party | 90.00 | 0 | 0 | Canceled | 2017-01-06 | Resort Hotel |
| 2 | 21043 | 0 | 83 | 2016 | February | 7 | 9 | 2 | 5 | 2 | 0.0 | 0 | BB | GBR | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | D | 0 | No Deposit | 6 | NULL | 0 | Transient | 26.00 | 0 | 0 | Check-Out | 2016-02-16 | Resort Hotel |
| 3 | 22591 | 0 | 0 | 2016 | October | 42 | 10 | 1 | 0 | 1 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 1 | 0 | 0 | A | A | 0 | No Deposit | 240 | NULL | 0 | Transient-Party | 56.00 | 0 | 1 | Check-Out | 2016-10-11 | Resort Hotel |
| 4 | 54136 | 1 | 187 | 2016 | July | 28 | 7 | 0 | 2 | 0 | 2.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | B | B | 0 | No Deposit | 9 | NULL | 0 | Transient-Party | 86.50 | 0 | 0 | Canceled | 2016-02-20 | City Hotel |
| 5 | 61873 | 1 | 41 | 2016 | December | 53 | 27 | 2 | 5 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | NULL | NULL | 0 | Transient-Party | 69.29 | 0 | 0 | Canceled | 2016-12-12 | City Hotel |
| 6 | 73719 | 1 | 258 | 2015 | July | 27 | 2 | 0 | 2 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 1 | 1 | 0 | A | A | 0 | No Deposit | 1 | NULL | 0 | Transient-Party | 62.80 | 0 | 0 | Canceled | 2014-10-17 | City Hotel |
| 7 | 48420 | 1 | 31 | 2016 | March | 13 | 23 | 0 | 1 | 2 | 0.0 | 0 | BB | ESP | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9 | NULL | 0 | Transient | 126.90 | 0 | 0 | Canceled | 2016-03-18 | City Hotel |
| 8 | 84433 | 0 | 22 | 2016 | February | 8 | 19 | 2 | 5 | 2 | 0.0 | 0 | BB | GBR | Direct | Direct | 0 | 0 | 0 | A | A | 0 | No Deposit | NULL | NULL | 0 | Transient | 100.00 | 1 | 1 | Check-Out | 2016-02-26 | City Hotel |
| 9 | 51422 | 1 | 322 | 2016 | May | 21 | 19 | 1 | 3 | 2 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 31 | NULL | 120 | Transient | 80.00 | 0 | 0 | Canceled | 2016-02-10 | City Hotel |
Last rows
| df_index | IsCanceled | LeadTime | ArrivalDateYear | ArrivalDateMonth | ArrivalDateWeekNumber | ArrivalDateDayOfMonth | StaysInWeekendNights | StaysInWeekNights | Adults | Children | Babies | Meal | Country | MarketSegment | DistributionChannel | IsRepeatedGuest | PreviousCancellations | PreviousBookingsNotCanceled | ReservedRoomType | AssignedRoomType | BookingChanges | DepositType | Agent | Company | DaysInWaitingList | CustomerType | ADR | RequiredCarParkingSpaces | TotalOfSpecialRequests | ReservationStatus | ReservationStatusDate | Hotel | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59685 | 78848 | 0 | 29 | 2015 | October | 42 | 14 | 0 | 4 | 2 | 2.0 | 0 | BB | FIN | Online TA | TA/TO | 0 | 0 | 0 | F | F | 0 | No Deposit | 9 | NULL | 0 | Contract | 163.58 | 0 | 1 | Check-Out | 2015-10-18 | City Hotel |
| 59686 | 8369 | 1 | 2 | 2016 | September | 39 | 24 | 2 | 1 | 2 | 2.0 | 0 | BB | BEL | Online TA | TA/TO | 0 | 0 | 0 | G | G | 0 | No Deposit | 240 | NULL | 0 | Transient | 165.00 | 0 | 0 | Canceled | 2016-09-23 | Resort Hotel |
| 59687 | 1182 | 0 | 96 | 2015 | August | 34 | 17 | 1 | 5 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 240 | NULL | 0 | Transient-Party | 134.00 | 0 | 3 | Check-Out | 2015-08-23 | Resort Hotel |
| 59688 | 91307 | 0 | 45 | 2016 | June | 25 | 17 | 1 | 2 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 1 | NULL | 0 | Transient-Party | 65.00 | 0 | 1 | Check-Out | 2016-06-20 | City Hotel |
| 59689 | 110522 | 0 | 123 | 2017 | April | 17 | 24 | 1 | 3 | 2 | 0.0 | 0 | BB | FRA | Direct | Direct | 0 | 0 | 0 | A | A | 0 | No Deposit | 14 | NULL | 0 | Transient | 105.75 | 0 | 1 | Check-Out | 2017-04-28 | City Hotel |
| 59690 | 42302 | 0 | 41 | 2015 | September | 36 | 4 | 0 | 1 | 2 | 0.0 | 0 | HB | ITA | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 39 | NULL | 38 | Transient-Party | 110.00 | 0 | 0 | Check-Out | 2015-09-05 | City Hotel |
| 59691 | 4829 | 0 | 171 | 2016 | April | 15 | 4 | 1 | 1 | 1 | 0.0 | 0 | HB | DEU | Groups | TA/TO | 0 | 0 | 0 | A | A | 1 | Non Refund | 298 | NULL | 0 | Transient-Party | 54.50 | 0 | 0 | Check-Out | 2016-04-06 | Resort Hotel |
| 59692 | 54784 | 1 | 177 | 2016 | July | 31 | 26 | 0 | 4 | 2 | 0.0 | 0 | SC | ROU | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9 | NULL | 0 | Transient | 80.75 | 0 | 1 | Canceled | 2016-03-05 | City Hotel |
| 59693 | 110326 | 0 | 31 | 2017 | April | 16 | 21 | 2 | 3 | 2 | 0.0 | 0 | BB | DEU | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 21 | NULL | 0 | Transient-Party | 85.00 | 0 | 0 | Check-Out | 2017-04-26 | City Hotel |
| 59694 | 30708 | 0 | 0 | 2016 | December | 49 | 1 | 0 | 1 | 2 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | A | A | 1 | No Deposit | NULL | NULL | 0 | Transient | 43.00 | 0 | 0 | Check-Out | 2016-12-02 | Resort Hotel |